package com.example.auth.mapper;

import com.example.auth.domain.User;
import com.example.auth.domain.UserPhone;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
* @author CETC
* @description 针对表【user_phone_0】的数据库操作Mapper
* @createDate 2025-11-01 16:17:14
* @Entity com.example.system.auth.domain.UserPhone0
*/
public interface UserPhoneMapper extends BaseMapper<UserPhone> {

    @Select("SELECT * FROM ${tableName} WHERE  user_phone=#{phone} ")
    public UserPhone getByPhone(@Param("tableName")String tableName, @Param("phone")String userName);

    @Update("delete from ${tableName} where user_phone=#{phone}")
    public int deleteByPhone(@Param("tableName")String tableName,@Param("phone")String phone);
}




